package com.hotel.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.hotel.entity.HouseStatement;

public interface HouseStatementMapper {
    int deleteByPrimaryKey(Integer statementId);

    int insert(HouseStatement record);

    int insertSelective(HouseStatement record);

    HouseStatement selectByPrimaryKey(Integer statementId);

    int updateByPrimaryKeySelective(HouseStatement record);

    int updateByPrimaryKey(HouseStatement record);
    
    /**
     * 按月度查询入住统计
     * @param month
     * @return
     */
    List<HouseStatement> findMonthHouseStatement(@Param("year")String year,@Param("month")String month);
    
    /**
     * 按年度查询入住统计
     * @param year
     * @return
     */
    List<HouseStatement> findAnnualHouseStatement(@Param("year")String year);
}